﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using WF_Business;

namespace Business.Admin
{
    /// <summary>
    /// 信息公告管理
    /// </summary>
    public class ClsInfoManage
    {
        public DataTable GetAllInfo(string strType,string strId)
        {
            string strSql ="select * from ut_tzggxw t where 1=1";
            if(!string.IsNullOrEmpty(strType))
            {
                strSql += string.Format(@" and lx='{0}'", strType);
            }
            if (!string.IsNullOrEmpty(strId))
            {
                strSql += string.Format(@" and id='{0}'", strId);
            }
            DataTable dt;
            SysParams.OAConnection().RunSql(strSql, out dt);
            return dt;
        }
    }
}
